package com.showde.shoppingmall.db.constant;

public class BillConstant extends ConstantBase {

	public static final String TABLENAME = "t_bill";

	public static final String BILLID = "BILLID"; // 订单ID
	public static final String BILLTIME = "BILLTIME";// 订单时间
	public static final String BILLTOTALPRICE = "BILLTOTALPRICE";// 订单总价
	public static final String BILLADDRESS = "BILLADDRESS";// 订单地址
	public static final String BILLSTATUS = "BILLSTATUS";// 订单状态
	public static final String USERID = "USERID"; // 用户id

	public static final int COLUMN_BILLID = 1; // 订单ID
	public static final int COLUMN_BILLTIME = 2;// 订单时间
	public static final int COLUMN_BILLTOTALPRICE = 3;// 订单总价
	public static final int COLUMN_BILLADDRESS = 4;// 订单地址
	public static final int COLUMN_BILLSTATUS = 5;// 订单状态
	public static final int COLUMN_USERID = 6;// 用户id

	public static final String[] dbColumns = new String[] { BILLID, BILLTIME,
			BILLTOTALPRICE, BILLADDRESS, BILLSTATUS, USERID };

	public static final String SQL_CREAT = "create table 't_bill'("
			+ "'_id' int primary key, " + "'BILLID' int not null, "
			+ "'BILLTIME' varchar(50), " + "'BILLTOTALPRICE' float, "
			+ "'BILLADDRESS' varchar(100), " + "'BILLSTATUS' int, "
			+ "'USERID' varchar(20))";

}
